[Solved] VBA: Determining merged cell ranges I would first say, avoid merging cells in Excel as it will often cause grief. A better option is the Center Across Selection via Format>Cells>Alignment- ...
